package com.horse.cloud.data.access.boss.mapperInterface;

import com.horse.cloud.data.access.BaseMapper;
import com.horse.cloud.data.access.boss.entity.ClBossUser;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ClBossUserMapper  extends BaseMapper<ClBossUser,Object> {



    @Select("<script>" +
                "select  id, user_number userNumber, login_name loginName, real_name, password, sex, birthday, id_card, position,  " +
                "mobile_phone, email, join_time, last_login, last_ip, sum_login, online_time, " +
                "detail_explain, status, create_user, create_time, update_user, update_time " +
                    "from  " +
                "CL_BOSS_USER   " +
                "<trim prefix=\"WHERE\" prefixOverrides=\"AND\"> " +
                    "<if test=\"id != null and id != ''\">  " +
                        "AND id = #{id} " +
                    "</if> " +
                "</trim>" +
            "</script>")
    List<ClBossUser> getUser(@Param("id") Integer id);


}